I created this visual using Unreal Engine 5.3, Kitbash3D Cargo (mainly Future Slums 2 kit and some assets from Cyber District), Quixel Megascans for a few materials and ground blend material, a VDB smoke from pixellab.net and used the Niagara Realistic Starter VFX Pack from FX Cat UA at Unreal Marketplace for things like dust and smoke fx. This visual took no longer than 8 hours to create.

https://kitbash3d.com/products/future-slums-2